
  create table jms_dwd.dwd_yl_oms_order_mark_expand_base_dt(
   input_date date comment '录入日期',
  `id` bigint COMMENT '主键ID',
  `order_id` bigint COMMENT '订单ID',
  `waybill_id` varchar(80) COMMENT '运单号',
  `order_source_code` varchar(100) COMMENT '订单来源code',
  `field_name` varchar(100) COMMENT '打标字段名称',
  `field_value` varchar(80) COMMENT '打标字段值',
  `input_time` datetime COMMENT '录入时间',
  `update_time` datetime COMMENT '修改时间',
  `is_delete` bigint COMMENT '是否删除 1：未删除 2：已删除'
  )ENGINE = OLAP
DUPLICATE KEY(input_date,id,order_id,waybill_id)
COMMENT '订单打标拓展表'
PARTITION BY RANGE(input_date)
(START ('2023-07-01') END ('2023-09-20') EVERY (INTERVAL 1 day)
)
DISTRIBUTED BY HASH(waybill_id) BUCKETS 20
PROPERTIES (
'replication_num' = '3',
'dynamic_partition.enable' = 'true',
'dynamic_partition.time_unit' = 'DAY',
'dynamic_partition.time_zone' = 'Asia/Shanghai',
'dynamic_partition.start' = '-90',
'dynamic_partition.end' = '3',
'dynamic_partition.prefix' = 'p',
'dynamic_partition.buckets' = '20',
'in_memory' = 'false',
'storage_format' = 'V2'
)